﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

IF NOT EXISTS (SELECT * FROM dbo.Configuration WHERE ConfigType = 'HashUserId') 
INSERT INTO dbo.Configuration
(
	ConfigType,
	ConfigValue,
	Description
)
SELECT
	'HashUserId',
	1,
	'Determines if the UserId should be hased for security reasons'



IF NOT EXISTS (SELECT * FROM dbo.Configuration WHERE ConfigType = 'TrackParameterValues')
INSERT INTO dbo.Configuration
(
	ConfigType,
	ConfigValue,
	Description
)
SELECT
	'TrackParameterValues',
	1,
	'Determines if the parameters should be tracked at all'


